//package com.example.binpacking.mapper;
//
//
//import com.baomidou.mybatisplus.core.mapper.BaseMapper;
//import com.example.binpacking.model.OrderMessage;
//import org.apache.ibatis.annotations.Mapper;
//import org.apache.ibatis.annotations.Param;
//import org.apache.ibatis.annotations.Select;
//import java.util.List;
//@Mapper
//public interface OrderMessageMapper extends BaseMapper<OrderMessage> {
//    //查询订单的一些数据
//    @Select("select  do_code,MD5(warehouse_sku) as warehouse_sku,MD5(store_name) as store_name,box_size," +
//            "SUBSTRING_INDEX(SUBSTRING_INDEX(box_size, '*', 1), '*', -1) AS length,\n" +
//            "  SUBSTRING_INDEX(SUBSTRING_INDEX(box_size, '*', 2), '*', -1) AS weight,\n" +
//            "  SUBSTRING_INDEX(SUBSTRING_INDEX(box_size, '*', 3), '*', -1) AS height" +
//            ",per_box_weight,ship_time,created_at" +
//            " from  ods_eccang_api_deliver_outbound_batch_20240318 where ship_time between #{startTime} and #{endTime}")
//    List<OrderMessage> findOrderByTime(@Param("startTime") String startTime,
//                                       @Param("endTime") String endTime);
//
//
//    @Select("select  do_code,MD5(warehouse_sku) as warehouse_sku,MD5(store_name) as store_name,box_size," +
//            "SUBSTRING_INDEX(SUBSTRING_INDEX(box_size, '*', 1), '*', -1) AS length,\n" +
//            "  SUBSTRING_INDEX(SUBSTRING_INDEX(box_size, '*', 2), '*', -1) AS weight,\n" +
//            "  SUBSTRING_INDEX(SUBSTRING_INDEX(box_size, '*', 3), '*', -1) AS height" +
//            ",per_box_weight,ship_time,created_at" +
//            " from  ods_eccang_api_deliver_outbound_batch_20240318 where ship_time between '2024-01-01 00:00:00' and '2024-01-13 00:00:00'")
//    List<OrderMessage> selectByTime();
//
//
//
//}
